EMT Practice Test

1. Question Content...

---

Question1: A new record is appended to the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

Question2: A developer uses an API to send data to a Marketing Cloud data extension once every five minutes using the REST API. They notice data does not always write to the data extension, leading to data loss.
Which three best practices are recommended to avoid this issue? Choose 3 answers

Question3: Which of the following is a valid comment within an AMPscript code block? Choose 1.

Question4: Certification Aid wants to add new customers to a cross-channel welcome campaign when they register on the company website. Which API should be used for this? Choose 1.

Question5: Landing pages can use which SSJS library? 1. Core LibraryZ. Platform Library 3. SSJS Library

Question6: NTO is using an asynchronous SOAP API call to the TriggerSend object to send order confirmation email to their customers. Which API object and attribute should be used to retrieve the status of the API call?

Question7: Which programming language should be used in email messages? Choose 1.

Question8: A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers

Question9: A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture tool will call the Marketing Cloud API to create a data extension every time a new lead form is published. The created data extension's name should match the name of the form exactly.
Which API feature could the developer use to dynamically create these data extensions?

Question10: A developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Which feature should handle this scenario?

Question11: A developer identified a use case where a triggered send of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls. When the REST call is made, a "401 Unauthorized" error is returned. What is the first thing the developer should check?

Question12: A developer is making an API REST call to trigger an email send. An access token is used to authenticate the call.
How long are Marketing Cloud v1 access tokens valid?

Question13: A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best practice should the developer follow to control the unique and default content?

Question14: Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.

Question15: Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.

Question16: Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.

Question17: A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

Question18: A developer started a Contact Delete process that is now complete.
In which two places would the Contact Delete process remove data? Choose 2 answers

Question19: A developer created an email with AMPscript variable as the subject line. The subject line variable was recently updated, but when testing the email, the wrong subject line continues to appear in the inbox. The developer thinks another, outdated, subject line variable is declared within the email. Where could the outdated variable be located?

Question20: Customer data has been imported into a staging data extension and needs to be normalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.
Which SQL keywords and functions could be used to write the query'' Choose 2 answers

Question21: A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center. Which method could be used to support the dynamic functionality?

Question22: From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

Question23: A developer wants to set a variable to use a field from a Sendable Data Extension.
Which two options could be used in an AMPscript block to set the variable as a 'First Name" field from a Sendable Data Extension used to send the email? Choose 2 answers

Question24: A developer is using the legacy endpoint www.exacttargetapis.com and has been asked to switch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?

Question25: A developer wants to create a Send Log Data Extension to increase efficiency with tracking email sends.
Which two best practices should the developer remember when configuring the Send Log Data Extension? Choose 2 answers

Question26: NTO is using a mobile campaign to collect an email addresses of interested subscribers. Using AMPscript's API functions they will send a confirmation email when an email is texted into their short code. Which two objects are required to successfully create a TriggerSend object? Choose 2

Question27: A developer wants to expand the functionality of existing code which was written in AMPscript, but prefers to use Server-Side JavaScript (SSJS) for updates.
Which SSJS statement will retrieve the value of the AMPscript variable named subKey?

Question28: Northern Trail Outfitters (NTO) uses a numeric identifier for Subscriber Key. Customer data is stored in a data extension with the Subscriber Key set as a Primary Key.
Which step is required for NTO when creating relationships for this data extension in Data Designer'

Question29: A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?

Question30: A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension.
Which SELECT statement is optimal for returning all of the columns in the data extension?

Question31: Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.

Question32: A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for each month in the following way:
How should the developer use AMPscript to generate the total?

Question33: In what order is AMPscript evaluated before an email is sent?

Question34: When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

Question35: A developer wants to implement a newsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?

Question36: A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open Data Views. Which activities should the developer build to generate the data before transferring it to the SFTP?

Question37: A developer, who is new to Marketing Cloud, needs to design a landing page for a new customer. They choose to use Server-Side JavaScript (SSJS) due to their extensive knowledge of JavaScript from previous projects.
Which two features would the developer be able to leverage in their Server-Side code? Choose 2 answers

Question38: What is the purpose of the IF statement below?

Question39: A developer identified duplicate contacts and wants to delete roughly 10 million subscribers using Contact Delete. How could the process be expedited?

Question40: A developer wants to create an HTML table where rows will alternate background colors between white and red. The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator. What is the recommended AMPscript logic to determine the background color of each table row within the loop?

Question41: A developer receives Error Code 5 when performing a SOAP API call. The error states: "Cannot Perform 'Post' on objects of type 'SentEvent'".
What could be the issue?

Question42: NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns. They request a developer to create a query which aggregates clicks grouped by language of the recipient. Language is stored in a Profile Attribute. Which two Data Views would be included in the query? Choose 2 answer

Question43: A developer wants to configure an automation to import files placed on the SFTP shared by a customer's data vendor. The automation will start when a file matching a specific naming pattern is encountered in the Import folder. The first step of the automation is a File Import Activity referencing a substion string for the matching file. Which substituon string represents the name of the file?

Question44: Certification Aid sends an email to a newly imported List with Subscribers who have no associated Subscriber Key. Which value will become the Contact Key? Choose 1.

Question45: NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?

Question46: NTO wants to exclude sends to specific subscribers based on a business rule, which is defined in an Exclusion Script. Which three types of sends would support this functionality? Choose 3

Question47: Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and the file name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.

Question48: Where can the SSJS Core library be used? Choose 2.

Question49: NTO wants to exclude sending an email at send time to those with a record on the 'Exclude' Data Extension. The primary key on this data extension is Subscriber Key. How would a developer write the Exclusion Script?

Question50: A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2